Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_MVIEW_ANALYSIS

`ALL_MVIEW_ANALYSIS` describes the materialized views accessible to the current user. It provides additional information for analysis by applications. Minimal information is displayed for materialized views that do not support query rewrite (such as materialized views with remote master tables or nondeterministic functions).

Related Views

- `DBA_MVIEW_ANALYSIS` describes all such materialized views in the database.

- `USER_MVIEW_ANALYSIS` describes all such materialized views owned by the current user.

Note: All of the information in these views is also displayed in `ALL_MVIEWS` and its related views. Oracle recommends that you refer to `ALL_MVIEWS` for this information instead of these views.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the materialized view
`MVIEW_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the materialized view
`MVIEW_TABLE_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the container table (see next column)
`CONTAINER_NAME` | `VARCHAR2(30)` |  | Name of the internal container in which the materialized view data is held. Normally this is the same as `MVIEW_NAME`. For materialized views created prior to Oracle8i, the Oracle Database attaches the 6-byte prefix `SNAP$_`. If `MVIEW_NAME` has more than 19 bytes, the Oracle Database truncates the name to 19 bytes and adds a 4-byte sequence number as a suffix to produce a nonambiguous `CONTAINER_NAME`.
`LAST_REFRESH_SCN` | `NUMBER` |  | System change number (SCN) of the last refresh operation
`LAST_REFRESH_DATE` | `DATE` |  | `SYSDATE` of the last refresh
`REFRESH_METHOD` | `VARCHAR2(8)` |  | Default refresh method: `FORCE`, `FAST`, `COMPLETE`, or `NONE`
`SUMMARY` | `VARCHAR2(1)` |  | Whether this materialized view includes a `GROUP BY` clause or aggregation (`Y` | `N`)
`FULLREFRESHTIM` | `NUMBER` |  | Approximate refresh time, in seconds, for full refresh (defined only when `SUMMARY = Y`)
`INCREFRESHTIM` | `NUMBER` |  | Approximate refresh time, in seconds, for fast refresh (defined only when `SUMMARY = Y`)
`CONTAINS_VIEWS` | `VARCHAR2(1)` |  | Whether this materialized view contains a view in its definition (`Y` | `N`)
`UNUSABLE` | `VARCHAR2(1)` |  | Whether this materialized view is `UNUSABLE` (inconsistent data) (`Y` | `N`). A materialized view can be `UNUSABLE` if a system failure occurs during a full refresh.
`RESTRICTED_SYNTAX` | `VARCHAR2(1)` |  | Whether this materialized view had a restriction in its defining query that limits the use of query rewrite (`Y` | `N`). More complete information is provided by the `REWRITE_CAPABILITY` column of the `ALL_`, `DBA_`, and `USER_MVIEWS` views.
`INC_REFRESHABLE` | `VARCHAR2(1)` |  | Whether this materialized view can be fast refreshed (`Y` | `N`)
`KNOWN_STALE` | `VARCHAR2(1)` |  | Whether the data contained in the materialized view is known to be inconsistent with the master table data because that has been updated since the last successful refresh (`Y` | `N`)
`INVALID` | `VARCHAR2(1)` |  | Whether this materialized view is in an invalid state (inconsistent metadata) (`Y` | `N`)
`REWRITE_ENABLED` | `VARCHAR2(1)` |  | Whether this materialized view is currently enabled for query rewrite (`Y` | `N`)
`QUERY_LEN` | `NUMBER` |  | Length (in bytes) of the query field
`QUERY` | `LONG` |  | `SELECT` expression of the materialized view definition
`REVISION` | `NUMBER` |  | Reserved for internal use